Generate EFT remittance file
This form is used to generate an Electronic Funds Transfer file for all Payments records that were processed with a given automated Remittance # . The file generated is in standard ABA format accepted by most banks and financial institutions.
The form is displayed automatically after an Automated remittance action has been performed. However, if you decide not to create the EFT Data File immediately or you want to re-create the data file based on different information or parameters, you can activate it from the menu of the Automated remittance form at any time.
Features
- A payment processing date can be specified
- Definable reference text for payments
- Standard EFT Data File format generated in a location of your choice
- An EFT data file can be generated as many times as you like for the same Remittance ID
Generate EFT data file form
Module: Accounts payable
Category: Generate EFT remittance
Activation: Main > Accounts payable > Automated remittance > Special > Generate EFT data file
Form style: Single instance modal, ActionForm
Special actions available for users with Administrator permissions:
- None
Database rules:
- None
Field definitions
Drawing account
Reference: Select from list, Mandatory
This is the Account code of the account from which bank account details will be taken to insert into the generated EFT data file. This account will also be checked to ensure it is the same as each of the Drawing account in all of the Payments that were remitted with the specified Remittance # .
Remittance date
Reference: Date, Mandatory, QuickList
This is the date that will be inserted into the generated EFT Data File as the processing date for the remittance. This date does not have to be the same as the date on which the automated remittance was performed, although this is usually the case.
The date entered here is not stored in the database after the EFT file has been created.
Remittance ID
This is the Remittance # that was generated by actioning an Automated remittance for selected Payments. The Drawing account details for all payments relating to this Remittance # must match the account that you specified in the Drawing account field.
EFT Data File
Reference: Text(100), Mandatory
This is the full file name of the generated EFT data file. If the file already exists when you click on the OK button, you will be asked if you want to overwrite it.
To select an EFT data file, click on the >> button or press the QuickList Hot Key.